package com.trkj.dao.lzs;

import java.util.List;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.trkj.pojo.StaffInformation;


public interface StaffDAO extends CrudRepository<StaffInformation, Long>{
	
	@Query("SELECT s,sa FROM StaffInformation s inner join s.salaryAccount sa")
	public List<Object[]> find_emp_pay();
	
	@Query("SELECT s,sa FROM StaffInformation s inner join s.salaryAccount sa  where s.stainName like?1 or s.stainId like?1")
	public List<Object[]> query_By_idorname(String text);
	
	
}